Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
TenderTypeCode (FK) | A code which uniquely identifies the type of tender, for which the calculated in drawer figure exceeds the limit in the DrawerLimitRule. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
TillLimitRuleID (FK) | A unique system assigned identifier for the Drawer Limit Rule. | ID_TL_LM_RU | Identity | integer | TillLimitRule(RU_LM_TL) |
TillID (FK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | Till(AS_TL) |
LimitTypeCode | A mnemonic code that denotes which of the limits in the DrawerLimitRule have been exceeded. e.g. Warning, Lockout. | TY_LM | Code4 | char(4) | |
InTillAmount | The calculated in drawer amount of the Tender that exceeded the limit. | MO_TL | MoneyShortRetail | decimal(7,2) | |